Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 21312 |
| Missing cells | 31352 |
| Missing cells (%) | 7.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 4.5 MiB |
| Average record size in memory | 220.7 B |
Variable types
| NUM | 14 |
|---|---|
| CAT | 3 |
| BOOL | 3 |
| DATE | 1 |
Reproduction
| Analysis started | 2020-05-05 08:29:26.748862 |
|---|---|
| Analysis finished | 2020-05-05 08:30:51.471060 |
| Version | pandas-profiling v2.5.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
producto has a high cardinality: 72 distinct values | High cardinality |
month is highly correlated with quarter and 1 other fields | High Correlation |
quarter is highly correlated with month and 1 other fields | High Correlation |
weekofyear is highly correlated with quarter and 1 other fields | High Correlation |
udsstock has 8109 (38.0%) missing values | Missing |
udsventa has 5350 (25.1%) missing values | Missing |
udsprevisionempresa has 4948 (23.2%) missing values | Missing |
roll4wd_udsventa has 4164 (19.5%) missing values | Missing |
meanwd_udsventa has 1806 (8.5%) missing values | Missing |
roll4wd_udsstock has 2154 (10.1%) missing values | Missing |
roll4wd_udsprevisionempresa has 3939 (18.5%) missing values | Missing |
meanwd_udsprevisionempresa has 882 (4.1%) missing values | Missing |
weekday has 3024 (14.2%) zeros | Zeros |
sin_weekday has 3024 (14.2%) zeros | Zeros |
meanwd_udsprevisionempresa has 252 (1.2%) zeros | Zeros |
fecha
Date
| Distinct count | 296 |
|---|---|
| Unique (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 333.0 KiB |
| Minimum | 2019-06-05 00:00:00 |
|---|---|
| Maximum | 2020-03-26 00:00:00 |
Histogram
| Distinct count | 72 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 333.0 KiB |
| 64 | 296 |
|---|---|
| 61 | 296 |
| 50 | 296 |
| 48 | 296 |
| 12 | 296 |
| Other values (67) |
| Value | Count | Frequency (%) | |
| 64 | 296 | 1.4% | |
| 61 | 296 | 1.4% | |
| 50 | 296 | 1.4% | |
| 48 | 296 | 1.4% | |
| 12 | 296 | 1.4% | |
| 31 | 296 | 1.4% | |
| 40 | 296 | 1.4% | |
| 28 | 296 | 1.4% | |
| 89 | 296 | 1.4% | |
| 3 | 296 | 1.4% | |
| Other values (62) | 18352 | 86.1% |
Length
| Max length | 2 |
|---|---|
| Mean length | 1.902777778 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 100.0% |
| Value | Count | Frequency (%) | |
| Common | 10 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 10 | 100.0% |
| Distinct count | 2525 |
|---|---|
| Unique (%) | 19.1% |
| Missing | 8109 |
| Missing (%) | 38.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1464.94167992123 |
|---|---|
| Minimum | 1.0 |
| Maximum | 64729.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 333.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 30 |
| Q1 | 416 |
| median | 940 |
| Q3 | 1757 |
| 95-th percentile | 4231 |
| Maximum | 64729 |
| Range | 64728 |
| Interquartile range (IQR) | 1341 |
Descriptive statistics
| Standard deviation | 2505.118828 |
|---|---|
| Coefficient of variation (CV) | 1.710046798 |
| Kurtosis | 176.5901822 |
| Mean | 1464.94168 |
| Median Absolute Deviation (MAD) | 1150.580857 |
| Skewness | 10.55962398 |
| Sum | 19341625 |
| Variance | 6275620.344 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 9 | 62 | 0.3% | |
| 19 | 60 | 0.3% | |
| 39 | 56 | 0.3% | |
| 3 | 54 | 0.3% | |
| 969 | 53 | 0.2% | |
| 6 | 52 | 0.2% | |
| 930 | 51 | 0.2% | |
| 26 | 50 | 0.2% | |
| 1 | 45 | 0.2% | |
| 736 | 44 | 0.2% | |
| Other values (2515) | 12676 | 59.5% | |
| (Missing) | 8109 | 38.0% |
| Value | Count | Frequency (%) | |
| 1 | 45 | 0.2% | |
| 3 | 54 | 0.3% | |
| 5 | 19 | 0.1% | |
| 6 | 52 | 0.2% | |
| 8 | 20 | 0.1% |
| Value | Count | Frequency (%) | |
| 64729 | 1 | < 0.1% | |
| 57022 | 2 | < 0.1% | |
| 56215 | 1 | < 0.1% | |
| 51299 | 1 | < 0.1% | |
| 50827 | 1 | < 0.1% |
| Distinct count | 2484 |
|---|---|
| Unique (%) | 15.6% |
| Missing | 5350 |
| Missing (%) | 25.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1127.530447312367 |
|---|---|
| Minimum | 0.0 |
| Maximum | 41564.0 |
| Zeros | 25 |
| Zeros (%) | 0.1% |
| Memory size | 333.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 59 |
| Q1 | 339 |
| median | 669 |
| Q3 | 1364 |
| 95-th percentile | 3542 |
| Maximum | 41564 |
| Range | 41564 |
| Interquartile range (IQR) | 1025 |
Descriptive statistics
| Standard deviation | 1608.355983 |
|---|---|
| Coefficient of variation (CV) | 1.426441288 |
| Kurtosis | 144.0787428 |
| Mean | 1127.530447 |
| Median Absolute Deviation (MAD) | 889.8335557 |
| Skewness | 8.525744921 |
| Sum | 17997641 |
| Variance | 2586808.968 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 472 | 162 | 0.8% | |
| 944 | 109 | 0.5% | |
| 2361 | 99 | 0.5% | |
| 2755 | 82 | 0.4% | |
| 1416 | 79 | 0.4% | |
| 787 | 74 | 0.3% | |
| 3306 | 73 | 0.3% | |
| 590 | 72 | 0.3% | |
| 1180 | 71 | 0.3% | |
| 393 | 71 | 0.3% | |
| Other values (2474) | 15070 | 70.7% | |
| (Missing) | 5350 | 25.1% |
| Value | Count | Frequency (%) | |
| 0 | 25 | 0.1% | |
| 1 | 24 | 0.1% | |
| 2 | 35 | 0.2% | |
| 3 | 26 | 0.1% | |
| 4 | 31 | 0.1% |
| Value | Count | Frequency (%) | |
| 41564 | 1 | < 0.1% | |
| 39556 | 1 | < 0.1% | |
| 39202 | 1 | < 0.1% | |
| 37313 | 1 | < 0.1% | |
| 36211 | 1 | < 0.1% |
| Distinct count | 7052 |
|---|---|
| Unique (%) | 43.1% |
| Missing | 4948 |
| Missing (%) | 23.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4781.039721339525 |
|---|---|
| Minimum | 0.0 |
| Maximum | 102304.0 |
| Zeros | 93 |
| Zeros (%) | 0.4% |
| Memory size | 333.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 98 |
| Q1 | 1106.75 |
| median | 2639 |
| Q3 | 5903 |
| 95-th percentile | 16531 |
| Maximum | 102304 |
| Range | 102304 |
| Interquartile range (IQR) | 4796.25 |
Descriptive statistics
| Standard deviation | 6509.194795 |
|---|---|
| Coefficient of variation (CV) | 1.361460095 |
| Kurtosis | 26.59691195 |
| Mean | 4781.039721 |
| Median Absolute Deviation (MAD) | 4087.909794 |
| Skewness | 3.941289985 |
| Sum | 78236934 |
| Variance | 42369616.88 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 93 | 0.4% | |
| 2833 | 33 | 0.2% | |
| 1 | 31 | 0.1% | |
| 2 | 30 | 0.1% | |
| 4 | 29 | 0.1% | |
| 1700 | 25 | 0.1% | |
| 3306 | 24 | 0.1% | |
| 9918 | 23 | 0.1% | |
| 6612 | 23 | 0.1% | |
| 4250 | 22 | 0.1% | |
| Other values (7042) | 16031 | 75.2% | |
| (Missing) | 4948 | 23.2% |
| Value | Count | Frequency (%) | |
| 0 | 93 | 0.4% | |
| 1 | 31 | 0.1% | |
| 2 | 30 | 0.1% | |
| 3 | 14 | 0.1% | |
| 4 | 29 | 0.1% |
| Value | Count | Frequency (%) | |
| 102304 | 1 | < 0.1% | |
| 98998 | 1 | < 0.1% | |
| 98716 | 1 | < 0.1% | |
| 81475 | 1 | < 0.1% | |
| 76489 | 1 | < 0.1% |
promo
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 333.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 16480 | 77.3% | |
| 1 | 4832 | 22.7% |
festivo
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 333.0 KiB |
| 0 | |
|---|---|
| 1 | 576 |
| Value | Count | Frequency (%) | |
| 0 | 20736 | 97.3% | |
| 1 | 576 | 2.7% |
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9966216216216215 |
|---|---|
| Minimum | 0 |
| Maximum | 6 |
| Zeros | 3024 |
| Zeros (%) | 14.2% |
| Memory size | 333.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.994122996 |
|---|---|
| Coefficient of variation (CV) | 0.665457054 |
| Kurtosis | -1.240859336 |
| Mean | 2.996621622 |
| Median Absolute Deviation (MAD) | 1.706560446 |
| Skewness | 0.004656882354 |
| Sum | 63864 |
| Variance | 3.976526524 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0. 0.5 5.5 6. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 3 | 3096 | 14.5% | |
| 2 | 3096 | 14.5% | |
| 6 | 3024 | 14.2% | |
| 5 | 3024 | 14.2% | |
| 4 | 3024 | 14.2% | |
| 1 | 3024 | 14.2% | |
| 0 | 3024 | 14.2% |
| Value | Count | Frequency (%) | |
| 0 | 3024 | 14.2% | |
| 1 | 3024 | 14.2% | |
| 2 | 3096 | 14.5% | |
| 3 | 3096 | 14.5% | |
| 4 | 3024 | 14.2% |
| Value | Count | Frequency (%) | |
| 6 | 3024 | 14.2% | |
| 5 | 3024 | 14.2% | |
| 4 | 3024 | 14.2% | |
| 3 | 3096 | 14.5% | |
| 2 | 3096 | 14.5% |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 333.0 KiB |
| 4 | |
|---|---|
| 3 | |
| 1 | |
| 2 |
| Value | Count | Frequency (%) | |
| 4 | 6624 | 31.1% | |
| 3 | 6624 | 31.1% | |
| 1 | 6192 | 29.1% | |
| 2 | 1872 | 8.8% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 4 | 100.0% |
| Value | Count | Frequency (%) | |
| Common | 4 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 4 | 100.0% |
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.993243243243243 |
|---|---|
| Minimum | 1 |
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 333.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 8 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 3.661418958 |
|---|---|
| Coefficient of variation (CV) | 0.523565223 |
| Kurtosis | -1.215477346 |
| Mean | 6.993243243 |
| Median Absolute Deviation (MAD) | 3.109751644 |
| Skewness | -0.3460820536 |
| Sum | 149040 |
| Variance | 13.40598879 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 1. 1.5 2.5 6.5 11.5 12. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 12 | 2232 | 10.5% | |
| 10 | 2232 | 10.5% | |
| 8 | 2232 | 10.5% | |
| 7 | 2232 | 10.5% | |
| 1 | 2232 | 10.5% | |
| 11 | 2160 | 10.1% | |
| 9 | 2160 | 10.1% | |
| 2 | 2088 | 9.8% | |
| 6 | 1872 | 8.8% | |
| 3 | 1872 | 8.8% |
| Value | Count | Frequency (%) | |
| 1 | 2232 | 10.5% | |
| 2 | 2088 | 9.8% | |
| 3 | 1872 | 8.8% | |
| 6 | 1872 | 8.8% | |
| 7 | 2232 | 10.5% |
| Value | Count | Frequency (%) | |
| 12 | 2232 | 10.5% | |
| 11 | 2160 | 10.1% | |
| 10 | 2232 | 10.5% | |
| 9 | 2160 | 10.1% | |
| 8 | 2232 | 10.5% |
| Distinct count | 43 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.469594594594593 |
|---|---|
| Minimum | 1 |
| Maximum | 52 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 333.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 11 |
| median | 31 |
| Q3 | 42 |
| 95-th percentile | 50 |
| Maximum | 52 |
| Range | 51 |
| Interquartile range (IQR) | 31 |
Descriptive statistics
| Standard deviation | 15.95001268 |
|---|---|
| Coefficient of variation (CV) | 0.560247271 |
| Kurtosis | -1.228771251 |
| Mean | 28.46959459 |
| Median Absolute Deviation (MAD) | 13.65613587 |
| Skewness | -0.3250216912 |
| Sum | 606744 |
| Variance | 254.4029045 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 1. 1.5 12.5 23.5 51.5 52. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 47 | 504 | 2.4% | |
| 51 | 504 | 2.4% | |
| 7 | 504 | 2.4% | |
| 38 | 504 | 2.4% | |
| 6 | 504 | 2.4% | |
| 37 | 504 | 2.4% | |
| 5 | 504 | 2.4% | |
| 52 | 504 | 2.4% | |
| 36 | 504 | 2.4% | |
| 4 | 504 | 2.4% | |
| Other values (33) | 16272 | 76.4% |
| Value | Count | Frequency (%) | |
| 1 | 504 | 2.4% | |
| 2 | 504 | 2.4% | |
| 3 | 504 | 2.4% | |
| 4 | 504 | 2.4% | |
| 5 | 504 | 2.4% |
| Value | Count | Frequency (%) | |
| 52 | 504 | 2.4% | |
| 51 | 504 | 2.4% | |
| 50 | 504 | 2.4% | |
| 49 | 504 | 2.4% | |
| 48 | 504 | 2.4% |
working_day
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 187.3 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) | |
| True | 17712 | 83.1% | |
| False | 3600 | 16.9% |
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.004759498821957349 |
|---|---|
| Minimum | -0.9749279121818236 |
| Maximum | 0.9749279121818236 |
| Zeros | 3024 |
| Zeros (%) | 14.2% |
| Memory size | 333.0 KiB |
Quantile statistics
| Minimum | -0.9749279122 |
|---|---|
| 5-th percentile | -0.9749279122 |
| Q1 | -0.7818314825 |
| median | 0 |
| Q3 | 0.7818314825 |
| 95-th percentile | 0.9749279122 |
| Maximum | 0.9749279122 |
| Range | 1.949855824 |
| Interquartile range (IQR) | 1.563662965 |
Descriptive statistics
| Standard deviation | 0.7074387216 |
|---|---|
| Coefficient of variation (CV) | 148.6372301 |
| Kurtosis | -1.500182941 |
| Mean | 0.004759498822 |
| Median Absolute Deviation (MAD) | 0.6270716718 |
| Skewness | -0.01056263076 |
| Sum | 101.4344389 |
| Variance | 0.5004695448 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-0.97492791 -0.60785761 -0.21694187 0.21694187 0.60785761 0.8783797 0.97492791], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0.4338837391 | 3096 | 14.5% | |
| 0.9749279122 | 3096 | 14.5% | |
| -0.9749279122 | 3024 | 14.2% | |
| -0.7818314825 | 3024 | 14.2% | |
| -0.4338837391 | 3024 | 14.2% | |
| 0.7818314825 | 3024 | 14.2% | |
| 0 | 3024 | 14.2% |
| Value | Count | Frequency (%) | |
| -0.9749279122 | 3024 | 14.2% | |
| -0.7818314825 | 3024 | 14.2% | |
| -0.4338837391 | 3024 | 14.2% | |
| 0 | 3024 | 14.2% | |
| 0.4338837391 | 3096 | 14.5% |
| Value | Count | Frequency (%) | |
| 0.9749279122 | 3096 | 14.5% | |
| 0.7818314825 | 3024 | 14.2% | |
| 0.4338837391 | 3096 | 14.5% | |
| 0 | 3024 | 14.2% | |
| -0.4338837391 | 3024 | 14.2% |
cos_weekday
Real number (ℝ)
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.003795573654928178 |
|---|---|
| Minimum | -0.9009688679024191 |
| Maximum | 1.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 333.0 KiB |
Quantile statistics
| Minimum | -0.9009688679 |
|---|---|
| 5-th percentile | -0.9009688679 |
| Q1 | -0.9009688679 |
| median | -0.222520934 |
| Q3 | 0.6234898019 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1.900968868 |
| Interquartile range (IQR) | 1.52445867 |
Descriptive statistics
| Standard deviation | 0.7067816624 |
|---|---|
| Coefficient of variation (CV) | -186.2120793 |
| Kurtosis | -1.498346475 |
| Mean | -0.003795573655 |
| Median Absolute Deviation (MAD) | 0.6408877408 |
| Skewness | 0.0090077723 |
| Sum | -80.89126573 |
| Variance | 0.4995403184 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-0.90096887 -0.90096887 1. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| -0.222520934 | 3096 | 14.5% | |
| -0.9009688679 | 3096 | 14.5% | |
| -0.9009688679 | 3024 | 14.2% | |
| -0.222520934 | 3024 | 14.2% | |
| 0.6234898019 | 3024 | 14.2% | |
| 0.6234898019 | 3024 | 14.2% | |
| 1 | 3024 | 14.2% |
| Value | Count | Frequency (%) | |
| -0.9009688679 | 3024 | 14.2% | |
| -0.9009688679 | 3096 | 14.5% | |
| -0.222520934 | 3024 | 14.2% | |
| -0.222520934 | 3096 | 14.5% | |
| 0.6234898019 | 3024 | 14.2% |
| Value | Count | Frequency (%) | |
| 1 | 3024 | 14.2% | |
| 0.6234898019 | 3024 | 14.2% | |
| 0.6234898019 | 3024 | 14.2% | |
| -0.222520934 | 3096 | 14.5% | |
| -0.222520934 | 3024 | 14.2% |
stockMissingType
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 333.0 KiB |
| 0 | |
|---|---|
| 2 | |
| 1 | 1008 |
| Value | Count | Frequency (%) | |
| 0 | 13203 | 62.0% | |
| 2 | 7101 | 33.3% | |
| 1 | 1008 | 4.7% |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 3 | 75.0% | |
| Other_Punctuation | 1 | 25.0% |
| Value | Count | Frequency (%) | |
| Common | 4 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 4 | 100.0% |
| Distinct count | 11281 |
|---|---|
| Unique (%) | 65.8% |
| Missing | 4164 |
| Missing (%) | 19.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1091.6569891532538 |
|---|---|
| Minimum | 0.0 |
| Maximum | 28339.0 |
| Zeros | 26 |
| Zeros (%) | 0.1% |
| Memory size | 333.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 54 |
| Q1 | 360 |
| median | 676.3125 |
| Q3 | 1318.71875 |
| 95-th percentile | 3367.825 |
| Maximum | 28339 |
| Range | 28339 |
| Interquartile range (IQR) | 958.71875 |
Descriptive statistics
| Standard deviation | 1349.899337 |
|---|---|
| Coefficient of variation (CV) | 1.236559973 |
| Kurtosis | 43.96518431 |
| Mean | 1091.656989 |
| Median Absolute Deviation (MAD) | 826.6935037 |
| Skewness | 4.78625492 |
| Sum | 18719734.05 |
| Variance | 1822228.22 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 472 | 75 | 0.4% | |
| 7 | 55 | 0.3% | |
| 2 | 36 | 0.2% | |
| 944 | 35 | 0.2% | |
| 6 | 30 | 0.1% | |
| 4 | 26 | 0.1% | |
| 1 | 26 | 0.1% | |
| 0 | 26 | 0.1% | |
| 885 | 18 | 0.1% | |
| 708 | 18 | 0.1% | |
| Other values (11271) | 16803 | 78.8% | |
| (Missing) | 4164 | 19.5% |
| Value | Count | Frequency (%) | |
| 0 | 26 | 0.1% | |
| 1 | 26 | 0.1% | |
| 1.142857143 | 1 | < 0.1% | |
| 1.428571429 | 1 | < 0.1% | |
| 1.6 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 28339 | 1 | < 0.1% | |
| 22316.75 | 1 | < 0.1% | |
| 20309 | 1 | < 0.1% | |
| 19187.625 | 1 | < 0.1% | |
| 19128.5 | 1 | < 0.1% |
| Distinct count | 458 |
|---|---|
| Unique (%) | 2.3% |
| Missing | 1806 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1048.0396869596257 |
|---|---|
| Minimum | 1.0 |
| Maximum | 9651.846153846154 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 333.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 29.04761905 |
| Q1 | 347.6756757 |
| median | 698.8461538 |
| Q3 | 1241.131579 |
| 95-th percentile | 3304.3 |
| Maximum | 9651.846154 |
| Range | 9650.846154 |
| Interquartile range (IQR) | 893.4559033 |
Descriptive statistics
| Standard deviation | 1170.45711 |
|---|---|
| Coefficient of variation (CV) | 1.116806095 |
| Kurtosis | 12.02088122 |
| Mean | 1048.039687 |
| Median Absolute Deviation (MAD) | 771.8843392 |
| Skewness | 2.894202013 |
| Sum | 20443062.13 |
| Variance | 1369969.847 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 8 | 84 | 0.4% | |
| 1 | 84 | 0.4% | |
| 787 | 84 | 0.4% | |
| 379.425 | 43 | 0.2% | |
| 859.275 | 43 | 0.2% | |
| 362.8529412 | 43 | 0.2% | |
| 381.075 | 43 | 0.2% | |
| 1009 | 43 | 0.2% | |
| 3090.95 | 43 | 0.2% | |
| 285.675 | 43 | 0.2% | |
| Other values (448) | 18953 | 88.9% | |
| (Missing) | 1806 | 8.5% |
| Value | Count | Frequency (%) | |
| 1 | 84 | 0.4% | |
| 1.5 | 42 | 0.2% | |
| 2 | 42 | 0.2% | |
| 4 | 42 | 0.2% | |
| 4.333333333 | 42 | 0.2% |
| Value | Count | Frequency (%) | |
| 9651.846154 | 43 | 0.2% | |
| 7668.605263 | 42 | 0.2% | |
| 7015.538462 | 42 | 0.2% | |
| 6539.25641 | 42 | 0.2% | |
| 6464.5 | 43 | 0.2% |
| Distinct count | 12022 |
|---|---|
| Unique (%) | 62.8% |
| Missing | 2154 |
| Missing (%) | 10.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1442.005518955155 |
|---|---|
| Minimum | 1.0 |
| Maximum | 57022.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 333.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 44.12142857 |
| Q1 | 469.5 |
| median | 952.375 |
| Q3 | 1710.28125 |
| 95-th percentile | 3976.7375 |
| Maximum | 57022 |
| Range | 57021 |
| Interquartile range (IQR) | 1240.78125 |
Descriptive statistics
| Standard deviation | 2195.892139 |
|---|---|
| Coefficient of variation (CV) | 1.522804255 |
| Kurtosis | 122.3428235 |
| Mean | 1442.005519 |
| Median Absolute Deviation (MAD) | 1081.779656 |
| Skewness | 8.396315353 |
| Sum | 27625941.73 |
| Variance | 4821942.287 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 6 | 50 | 0.2% | |
| 9 | 46 | 0.2% | |
| 407 | 37 | 0.2% | |
| 1 | 32 | 0.2% | |
| 19 | 27 | 0.1% | |
| 930 | 27 | 0.1% | |
| 710 | 26 | 0.1% | |
| 116 | 25 | 0.1% | |
| 26 | 25 | 0.1% | |
| 3 | 24 | 0.1% | |
| Other values (12012) | 18839 | 88.4% | |
| (Missing) | 2154 | 10.1% |
| Value | Count | Frequency (%) | |
| 1 | 32 | 0.2% | |
| 2.25 | 1 | < 0.1% | |
| 3 | 24 | 0.1% | |
| 3.75 | 2 | < 0.1% | |
| 4.5 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 57022 | 1 | < 0.1% | |
| 51299 | 2 | < 0.1% | |
| 43633.75 | 1 | < 0.1% | |
| 42400.25 | 1 | < 0.1% | |
| 40756 | 4 | < 0.1% |
meanwd_udsstock
Real number (ℝ≥0)
| Distinct count | 502 |
|---|---|
| Unique (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1436.7039646740225 |
|---|---|
| Minimum | 27.714285714285715 |
| Maximum | 15575.92857142857 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 333.0 KiB |
Quantile statistics
| Minimum | 27.71428571 |
|---|---|
| 5-th percentile | 92.22580645 |
| Q1 | 545.5833333 |
| median | 1019.272727 |
| Q3 | 1821.266667 |
| 95-th percentile | 4069.222222 |
| Maximum | 15575.92857 |
| Range | 15548.21429 |
| Interquartile range (IQR) | 1275.683333 |
Descriptive statistics
| Standard deviation | 1574.786742 |
|---|---|
| Coefficient of variation (CV) | 1.096110807 |
| Kurtosis | 19.8513319 |
| Mean | 1436.703965 |
| Median Absolute Deviation (MAD) | 982.6044583 |
| Skewness | 3.59022737 |
| Sum | 30619034.9 |
| Variance | 2479953.281 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 27.71428571 53.96394231 58.51388889 69.98333333 70.42333333 ... 6529.45512821 9065.97916667 9535.51666667 10341.52604167 15575.92857143], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 1152.333333 | 85 | 0.4% | |
| 756 | 84 | 0.4% | |
| 1961.09375 | 43 | 0.2% | |
| 968.5806452 | 43 | 0.2% | |
| 3783.285714 | 43 | 0.2% | |
| 5748.56 | 43 | 0.2% | |
| 3859.789474 | 43 | 0.2% | |
| 1019.272727 | 43 | 0.2% | |
| 1321.291667 | 43 | 0.2% | |
| 715.1290323 | 43 | 0.2% | |
| Other values (492) | 20799 | 97.6% |
| Value | Count | Frequency (%) | |
| 27.71428571 | 42 | 0.2% | |
| 33.92307692 | 43 | 0.2% | |
| 42.71428571 | 43 | 0.2% | |
| 45.92857143 | 43 | 0.2% | |
| 52.3125 | 42 | 0.2% |
| Value | Count | Frequency (%) | |
| 15575.92857 | 42 | 0.2% | |
| 11012.21875 | 43 | 0.2% | |
| 9670.833333 | 42 | 0.2% | |
| 9400.2 | 42 | 0.2% | |
| 9193.291667 | 42 | 0.2% |
| Distinct count | 15468 |
|---|---|
| Unique (%) | 89.0% |
| Missing | 3939 |
| Missing (%) | 18.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4898.456518324823 |
|---|---|
| Minimum | 0.0 |
| Maximum | 102304.0 |
| Zeros | 122 |
| Zeros (%) | 0.6% |
| Memory size | 333.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 67.825 |
| Q1 | 1198 |
| median | 2770.75 |
| Q3 | 6009.5 |
| 95-th percentile | 16698.025 |
| Maximum | 102304 |
| Range | 102304 |
| Interquartile range (IQR) | 4811.5 |
Descriptive statistics
| Standard deviation | 6559.633452 |
|---|---|
| Coefficient of variation (CV) | 1.339122523 |
| Kurtosis | 25.04161269 |
| Mean | 4898.456518 |
| Median Absolute Deviation (MAD) | 4128.878475 |
| Skewness | 3.856323727 |
| Sum | 85100885.09 |
| Variance | 43028791.03 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 122 | 0.6% | |
| 1 | 22 | 0.1% | |
| 2 | 16 | 0.1% | |
| 5 | 13 | 0.1% | |
| 4 | 10 | < 0.1% | |
| 6 | 9 | < 0.1% | |
| 29 | 8 | < 0.1% | |
| 2.5 | 7 | < 0.1% | |
| 147 | 7 | < 0.1% | |
| 7 | 7 | < 0.1% | |
| Other values (15458) | 17152 | 80.5% | |
| (Missing) | 3939 | 18.5% |
| Value | Count | Frequency (%) | |
| 0 | 122 | 0.6% | |
| 0.1428571429 | 1 | < 0.1% | |
| 0.25 | 3 | < 0.1% | |
| 0.4 | 1 | < 0.1% | |
| 0.4285714286 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 102304 | 1 | < 0.1% | |
| 98716 | 1 | < 0.1% | |
| 85217.5 | 1 | < 0.1% | |
| 82986 | 1 | < 0.1% | |
| 81475 | 1 | < 0.1% |
| Distinct count | 477 |
|---|---|
| Unique (%) | 2.3% |
| Missing | 882 |
| Missing (%) | 4.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4222.22435998539 |
|---|---|
| Minimum | 0.0 |
| Maximum | 37273.0 |
| Zeros | 252 |
| Zeros (%) | 1.2% |
| Memory size | 333.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 23.9 |
| Q1 | 1175.210526 |
| median | 2710.674426 |
| Q3 | 5724.236842 |
| 95-th percentile | 13489.91892 |
| Maximum | 37273 |
| Range | 37273 |
| Interquartile range (IQR) | 4549.026316 |
Descriptive statistics
| Standard deviation | 4816.679958 |
|---|---|
| Coefficient of variation (CV) | 1.140792044 |
| Kurtosis | 8.587230732 |
| Mean | 4222.22436 |
| Median Absolute Deviation (MAD) | 3391.085812 |
| Skewness | 2.407909484 |
| Sum | 86260043.67 |
| Variance | 23200405.82 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 252 | 1.2% | |
| 147 | 84 | 0.4% | |
| 5862.794872 | 43 | 0.2% | |
| 1720.076923 | 43 | 0.2% | |
| 1724.578947 | 43 | 0.2% | |
| 4871.052632 | 43 | 0.2% | |
| 1569.974359 | 43 | 0.2% | |
| 2332.973684 | 43 | 0.2% | |
| 2651.421053 | 43 | 0.2% | |
| 12004.2973 | 43 | 0.2% | |
| Other values (467) | 19750 | 92.7% | |
| (Missing) | 882 | 4.1% |
| Value | Count | Frequency (%) | |
| 0 | 252 | 1.2% | |
| 2.5 | 42 | 0.2% | |
| 5.666666667 | 42 | 0.2% | |
| 5.888888889 | 42 | 0.2% | |
| 6.2 | 42 | 0.2% |
| Value | Count | Frequency (%) | |
| 37273 | 43 | 0.2% | |
| 33120.13158 | 42 | 0.2% | |
| 23130.45946 | 43 | 0.2% | |
| 23025.10256 | 43 | 0.2% | |
| 22957.05128 | 42 | 0.2% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
First rows
| fecha | producto | udsstock | udsventa | udsprevisionempresa | promo | festivo | weekday | quarter | month | weekofyear | working_day | sin_weekday | cos_weekday | stockMissingType | roll4wd_udsventa | meanwd_udsventa | roll4wd_udsstock | meanwd_udsstock | roll4wd_udsprevisionempresa | meanwd_udsprevisionempresa | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2019-06-05 | 1 | 18275.0 | 2833.0 | 102304.0 | 0.0 | 0.0 | 2 | 2 | 6 | 23 | True | 0.974928 | -0.222521 | 0.0 | 2833.0 | 3405.131579 | 18275.0 | 11012.218750 | 102304.0 | 37273.000000 |
| 1 | 2019-06-05 | 10 | 2267.0 | 1874.0 | 36888.0 | 1.0 | 0.0 | 2 | 2 | 6 | 23 | True | 0.974928 | -0.222521 | 0.0 | 1874.0 | 2440.763158 | 2267.0 | 1822.161290 | 36888.0 | 10102.540541 |
| 2 | 2019-06-05 | 11 | 2506.0 | 2755.0 | 31078.0 | 0.0 | 0.0 | 2 | 2 | 6 | 23 | True | 0.974928 | -0.222521 | 0.0 | 2755.0 | 2323.135135 | 2506.0 | 3987.666667 | 31078.0 | 10973.815789 |
| 3 | 2019-06-05 | 12 | 1279.0 | 1161.0 | 33661.0 | 0.0 | 0.0 | 2 | 2 | 6 | 23 | True | 0.974928 | -0.222521 | 0.0 | 1161.0 | 1143.368421 | 1279.0 | 1605.741935 | 33661.0 | 5724.236842 |
| 4 | 2019-06-05 | 13 | 2493.0 | 1603.0 | 32119.0 | 1.0 | 0.0 | 2 | 2 | 6 | 23 | True | 0.974928 | -0.222521 | 0.0 | 1603.0 | 1874.447368 | 2493.0 | 3113.843750 | 32119.0 | 8500.421053 |
| 5 | 2019-06-05 | 14 | 1332.0 | 1626.0 | 30253.0 | 0.0 | 0.0 | 2 | 2 | 6 | 23 | True | 0.974928 | -0.222521 | 0.0 | 1626.0 | 1801.435897 | 1332.0 | 1157.800000 | 30253.0 | 9599.657895 |
| 6 | 2019-06-05 | 15 | 1447.0 | 472.0 | 16814.0 | 0.0 | 0.0 | 2 | 2 | 6 | 23 | True | 0.974928 | -0.222521 | 0.0 | 472.0 | 781.750000 | 1447.0 | 1580.928571 | 16814.0 | 3691.052632 |
| 7 | 2019-06-05 | 16 | 1154.0 | 1446.0 | 27856.0 | 1.0 | 0.0 | 2 | 2 | 6 | 23 | True | 0.974928 | -0.222521 | 0.0 | 1446.0 | 1403.838710 | 1154.0 | 1348.041667 | 27856.0 | 7479.529412 |
| 8 | 2019-06-05 | 17 | 3755.0 | 2270.0 | 38503.0 | 0.0 | 0.0 | 2 | 2 | 6 | 23 | True | 0.974928 | -0.222521 | 0.0 | 2270.0 | 2352.871795 | 3755.0 | 2990.250000 | 38503.0 | 10634.894737 |
| 9 | 2019-06-05 | 18 | 2962.0 | 1794.0 | 39619.0 | 0.0 | 0.0 | 2 | 2 | 6 | 23 | True | 0.974928 | -0.222521 | 0.0 | 1794.0 | 1875.282051 | 2962.0 | 1152.333333 | 39619.0 | 9314.973684 |
Last rows
| fecha | producto | udsstock | udsventa | udsprevisionempresa | promo | festivo | weekday | quarter | month | weekofyear | working_day | sin_weekday | cos_weekday | stockMissingType | roll4wd_udsventa | meanwd_udsventa | roll4wd_udsstock | meanwd_udsstock | roll4wd_udsprevisionempresa | meanwd_udsprevisionempresa | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21302 | 2020-03-26 | 84 | NaN | NaN | 358.0 | 0.0 | 0.0 | 3 | 1 | 3 | 13 | True | 0.433884 | -0.900969 | 2.0 | 508.142857 | 285.000000 | 114.00 | 225.240000 | 1623.875 | 1240.307692 |
| 21303 | 2020-03-26 | 87 | 868.0 | NaN | 273.0 | 1.0 | 0.0 | 3 | 1 | 3 | 13 | True | 0.433884 | -0.900969 | 0.0 | 682.857143 | 329.350000 | 1066.00 | 356.620690 | 1376.250 | 1684.102564 |
| 21304 | 2020-03-26 | 88 | 57.0 | NaN | 231.0 | 0.0 | 0.0 | 3 | 1 | 3 | 13 | True | 0.433884 | -0.900969 | 0.0 | 441.857143 | 259.525000 | 72.00 | 103.133333 | 1161.000 | 1408.897436 |
| 21305 | 2020-03-26 | 89 | 21.0 | NaN | 213.0 | 0.0 | 0.0 | 3 | 1 | 3 | 13 | True | 0.433884 | -0.900969 | 0.0 | 529.714286 | 305.000000 | 43.50 | 45.928571 | 1071.000 | 1453.512821 |
| 21306 | 2020-03-26 | 9 | 930.0 | NaN | 1574.0 | 0.0 | 0.0 | 3 | 1 | 3 | 13 | True | 0.433884 | -0.900969 | 0.0 | 5622.857143 | 4046.615385 | 4554.00 | 2725.000000 | 7123.875 | 9005.923077 |
| 21307 | 2020-03-26 | 91 | 38.0 | NaN | 272.0 | 0.0 | 0.0 | 3 | 1 | 3 | 13 | True | 0.433884 | -0.900969 | 0.0 | 1284.714286 | 415.350000 | 31.25 | 97.185185 | 1219.125 | 1593.512821 |
| 21308 | 2020-03-26 | 94 | 947.0 | NaN | 229.0 | 0.0 | 0.0 | 3 | 1 | 3 | 13 | True | 0.433884 | -0.900969 | 0.0 | 548.142857 | 249.850000 | 574.25 | 543.500000 | 1145.750 | 1179.225000 |
| 21309 | 2020-03-26 | 96 | 465.0 | NaN | 266.0 | 1.0 | 0.0 | 3 | 1 | 3 | 13 | True | 0.433884 | -0.900969 | 0.0 | 460.571429 | 285.675000 | 737.25 | 491.931034 | 1327.125 | 1399.375000 |
| 21310 | 2020-03-26 | 97 | 395.0 | NaN | 235.0 | 0.0 | 0.0 | 3 | 1 | 3 | 13 | True | 0.433884 | -0.900969 | 0.0 | 151.857143 | 346.375000 | 434.00 | 310.258065 | 1177.750 | 1569.974359 |
| 21311 | 2020-03-26 | 98 | 95.0 | NaN | 243.0 | 0.0 | 0.0 | 3 | 1 | 3 | 13 | True | 0.433884 | -0.900969 | 0.0 | 371.857143 | 266.900000 | 559.25 | 428.666667 | 1237.875 | 1306.846154 |